package site.lyweb.mapper;

import org.apache.ibatis.annotations.Param;
import site.lyweb.domain.dto.StuCourseRelation;
import site.lyweb.domain.dto.TeaCourseRelation;
import site.lyweb.domain.dto.StudentCourse;
import site.lyweb.domain.query.StudentCourseQuery;

import java.math.BigDecimal;
import java.util.List;

/**
 * @author 深山老林
 * @description 针对表【student】的数据库操作Mapper
 * @createDate 2024-06-19 20:53:32
 * @Entity generator.domain.Student
 */
public interface StudentCourseMapper {

    int selectByCount(StudentCourseQuery studentCourseQuery);

    List<StudentCourse> selectByPage(StudentCourseQuery studentCourseQuery);

    boolean removeBatchByIds(List<String> idList);

    boolean removeById(String id);

    boolean insert(@Param("id") String id,@Param("studentId") String studentId,
                   @Param("courseId") String courseId,@Param("teacherId")String teacherId,
                   @Param("courseScore") BigDecimal courseScore);

    boolean update(@Param("id") String id,@Param("studentId") String studentId,
                   @Param("courseId") String courseId,@Param("teacherId")String teacherId,
                   @Param("courseScore") BigDecimal courseScore);

    StuCourseRelation getById(String id);
}




